package com.usian.springbootmysql.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.usian.springbootmysql.dao.CollegeDao;
import com.usian.springbootmysql.pojo.ResuitVo;
import com.usian.springbootmysql.pojo.SearchDto;
import com.usian.springbootmysql.pojo.TbCollege;
import com.usian.springbootmysql.service.CollegeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;

import java.util.List;

@Service
public class CollegeServiceImpl extends ServiceImpl<CollegeDao, TbCollege> implements CollegeService {
    @Autowired
    private CollegeDao collegeDao;

    @Override
    public ResuitVo saveCollege(TbCollege tbCollege){
        QueryWrapper<TbCollege> query=new QueryWrapper<TbCollege>();
        query.eq("name",tbCollege.getName());
        int  count=collegeDao.selectCount(query);
        if (count>0){
            return  new ResuitVo(201,"名称存在",null);
        }
        else{
            collegeDao.insert(tbCollege);
            return  new ResuitVo(200,"添加成功",null);
        }

    }

    @Override
    public List<TbCollege> search(int status) {
        LambdaQueryWrapper<TbCollege> query=new LambdaQueryWrapper<TbCollege>();
        query.eq(TbCollege::getStatus,status);
        List<TbCollege> list=collegeDao.selectList(query);
        return list;
    }

    @Override
    public List<TbCollege> searchVo(TbCollege tbCollege) {
        LambdaQueryWrapper<TbCollege> query =new LambdaQueryWrapper<TbCollege>();
        if (!StringUtils.isEmpty(tbCollege.getName())){
            query.like(TbCollege::getName,tbCollege.getName());
        }
        if (tbCollege.getStatus()!=null){
            query.eq(TbCollege::getStatus,tbCollege.getStatus());
        }


        List<TbCollege> list=collegeDao.selectList(query);
        return list;
    }

    @Override
    public IPage<TbCollege> searchPage(SearchDto searchDto) {
       IPage<TbCollege> page=new Page<TbCollege>(searchDto.getPage(),searchDto.getSize());
       LambdaQueryWrapper<TbCollege> query=new LambdaQueryWrapper<TbCollege>();
        if (!StringUtils.isEmpty(searchDto.getName())){
            query.like(TbCollege::getName,searchDto.getName());
        }
        if (searchDto.getStatus()!=null){
            query.eq(TbCollege::getStatus,searchDto.getStatus());
        }
      IPage<TbCollege>list=  collegeDao.selectPage(page,query);
        return  list;
    }
}
